The format of the custom value list file described in Managing custom value lists is as follows. The file should be formatted as standard comma-separated value (CSV) text and consist of two sections named FIELD_CODES and FIELD_VALUES separated by an empty line. Each section should contain a header line that defines the columns named Property, Value, and Description. The third and subsequent lines of each section define the values in the list.
When the file is previewed as described in Managing custom value lists, Project Portal will analyze the file with the following rules:
Following is an example custom value list file.
FIELD_CODES Property,Value,Description 1351_Area,Area,Area description 1355_Target,Target value,Target description 504_Area,Area,Area description 504_Discipline,Discipline,Discipline description FIELD_VALUES Property,Value,Description 1351_Area,, 1351_Area,*, 1351_Area,50,Area 50 1351_Area,60,Area 60 1351_Area,90,Area 90 1351_Area,90a,Area 90a 1351_Area,100,0
In this example, the FIELD_VALUES section provides values for the 1351_Area value list only for simplicity. Also in this example, specifying empty values for Value and Description accepts empty values for the field on the property page. Specifying an asterisk (*) accepts any value in addition to those shown in the list.